package com.hist.medical_treatment.dao;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import com.hist.medical_treatment.entity.Scheduling;

@Mapper
public interface SchedulingDao { 
	  @Select("select scheduling.ID,schedDate,noon,userID,user.realName,constantitem.constantName,department.deptName,registName from scheduling,user,department,registlevel,constantitem where scheduling.deptID=#{deptID} and scheduling.deptID=department.ID and user.ID=scheduling.userID and user.registLeID=#{registLeID} and user.registLeID=registlevel.ID and constantitem.ID=user.doctitleID order by schedDate,noon")
      List<Scheduling> getScheduling(Integer deptID,Integer registLeID);
}
